storepsydney%20night

In concatenations of two different data types, Oracle Database returns the data type that results in a lossless conversion. oracle live sql Therefore, if one of the arguments is a LOB, then the returned value is a LOB. oracle cloud login If one of the arguments is a national data type, then the returned value is a national data type For example: CONCAT ( CLOB, NCLOB) returns NCLOB